﻿<%@ Page Language="VB" AutoEventWireup="false" CodeFile="eod.aspx.vb" Inherits="eod" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    Query Strings = storename,dateupload,fileuploading,method

    </div>
    </form>
    SELECT TOP 1000 [eKey]
      ,[storename]
      ,[dateupload]
      ,[fileuploading]
      ,[method]
  FROM [Management_Info_Sys].[dbo].[eod_items]
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" DeleteCommand="DELETE FROM [eod_items] WHERE [eKey] = @eKey" InsertCommand="INSERT INTO [eod_items] ([storename], [dateupload], [fileuploading], [method]) VALUES (@storename, @dateupload, @fileuploading, @method)" SelectCommand="SELECT * FROM [eod_items]" UpdateCommand="UPDATE [eod_items] SET [storename] = @storename, [dateupload] = @dateupload, [fileuploading] = @fileuploading, [method] = @method WHERE [eKey] = @eKey">
        <DeleteParameters>
            <asp:Parameter Name="eKey" Type="Int64" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="storename" Type="String" />
            <asp:Parameter Name="dateupload" Type="String" />
            <asp:Parameter Name="fileuploading" Type="String" />
            <asp:Parameter Name="method" Type="String" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="storename" Type="String" />
            <asp:Parameter Name="dateupload" Type="String" />
            <asp:Parameter Name="fileuploading" Type="String" />
            <asp:Parameter Name="method" Type="String" />
            <asp:Parameter Name="eKey" Type="Int64" />
        </UpdateParameters>
    </asp:SqlDataSource>
</body>
</html>
